What is your Create Queries with Specific Results in Access issue?
Responses:
Displaying Part of a Field using an Access Query...
Duplicate Records in Access Queries...
Querying Values using Queries in Access...
How to: Retrieve a range of records using a query
How to: Retrieve records with the current date using query
How to: Search for all records that begin with a certain character
How to: Search for text that includes an operator (e.g. AND, OR, etc.)
How to: Select records based on a combination of two fields
How to: Select records that match more than one criteria
How to: Select records that match one criterion
How to: Select records using wildcards